<?php
include_once '../data/database_dal.php';

class BlackDAL extends DatabaseDAL
{
    function update($id, $rfqID, $carbonContent, $particleSize, $filler, $carrier, $finalApp, $techRequirement, $qcRequirement, $contactRequirement, $ploymerMFI, $customerResin, $inTime, $inUser)
    {
        echo $customerResin;
        $this->connect();
        $result = $this->mysqli->query("call pr_black_update('". $id ."', '". $rfqID ."', '". $carbonConent ."', '". $particleSize ."', '". $filler ."', '". $carrier ."',
                                                    '". $finalApp ."', '". $techRequirement ."', '". $qcRequirement ."', '". $contactRequirement ."', '". $ploymerMFI ."', '". $customerResin ."',
                                                    '". $inTime ."', '". $inUser ."')");
        $this->close();
        return $result;
    }

    function get($where)
    {
        $this->connect();
        return $this->mysqli->query("call pr_user_get(".'"'.$where.'"'.")");
        $this->close();
        return $result;
    }

    function getAll($orderBy)
    {
        $this->connect();
        $result = $this->mysqli->query("call pr_user_get(".'"'.$orderBy.'"'.")");
        $this->close();
        return $result;
    }

    function delete($id)
    {
        $this->connect();
        $result = $mysqli->query("call pr_black_delete('". $id ."')");
        $this->close();
        return $result;
    }
}

?>
